Use of a star or snowflake schema to organize the data within the database 使用星型架構(gòu)或雪花架構(gòu)來組織數(shù)據(jù)庫內(nèi)的數(shù)據(jù)。
When you define a dimension based on a snowflake schema , which is where dimension attributes are derived from multiple related tables , an attribute relationship is automatically defined as follows 當(dāng)您基于雪花型架構(gòu)(在該架構(gòu)中,維度屬性派生自多個(gè)相關(guān)的表)定義維度時(shí),會按如下方式自動(dòng)定義屬性關(guān)系:
For the inquiring convenience , comprehensive service and the following data digging , all the tables of system are grouping , and re - edited into “ star schema ” or “ snowflake schema ” . hibernate is an object - relation mapping software which is more and more popular 在本系統(tǒng)中為了方便查詢,給用戶提供更全面的服務(wù)以及下一步要開展數(shù)據(jù)挖掘等工作,將所有數(shù)據(jù)表分組,重新設(shè)計(jì)表結(jié)構(gòu)實(shí)現(xiàn)了“雪花型”或“星型”多維數(shù)據(jù)模型。
In the process of building the multidimensional data model , we made some mends on the time dimension , adapted the time model based on competition , and this model provided enough information for the later analysis based on time . and contempary , this paper used a new schema called star cluster schema as the basic structure of the multidimensional data model . the cluster schema is the joint of star schema and snowflake schema , it inherits their merits , and mends their disadvantages 在具體的建模過程中,對時(shí)間維作了一定的修正,提出了一種基于競爭機(jī)制的時(shí)間維模型,為基于時(shí)間的分析提供了更加充分的信息;同時(shí)本文也對常用的多維數(shù)據(jù)模型的結(jié)構(gòu)作了改進(jìn),采用了一種稱作為星族模式的結(jié)構(gòu),這種結(jié)構(gòu)結(jié)合了星型模式和雪片模式的優(yōu)點(diǎn),同時(shí)又對各自的缺點(diǎn)進(jìn)行了修正,并在實(shí)際中得到了很好的應(yīng)用。